package com.kkb.dao;

import com.kkb.bean.FileTable;
import com.kkb.bean.OrderTable;
import com.kkb.vo.dataanalysis.HourData;
import com.kkb.vo.dataanalysis.TopProductVo;
import org.apache.ibatis.annotations.Param;
import com.kkb.vo.dianpugaikuang.SelectOrderSReq;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;
import java.util.Map;

@Repository
public interface OrderTableMapper extends Mapper<OrderTable> {

    public List<OrderTable> queryOrderByParam(Integer commodityType);

    List<HourData> selectHourData(@Param("userId") Integer userId, @Param("startDate") String startDate, @Param("endDate") String endDate);


    List<OrderTable> selectOrder(@Param("userId") Integer userId, @Param("status") int status, @Param("date") String date);

    List<HourData> selectOrderPayedNum(@Param("userId") Integer userId, @Param("startTime") String startTime, @Param("endTime") String endTime);

    List<HourData> selectPayedUserNum(@Param("userId") Integer userId, @Param("startTime") String startTime, @Param("endTime") String endTime);

     //sfl
    Integer selectJOrder(SelectOrderSReq selectOrderSReq);


    List<TopProductVo> selectPayTop5File(Integer userId);

    List<TopProductVo> selectFangKeTop5File(Integer userId);
}